Dataset statistics
| Number of variables | 10 |
|---|---|
| Number of observations | 5695 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 489.4 KiB |
| Average record size in memory | 88.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Unsupported | 1 |
monetary is highly overall correlated with qtd_compras and 1 other fields | High correlation |
frequency is highly overall correlated with qtd_compras | High correlation |
qtd_compras is highly overall correlated with monetary and 3 other fields | High correlation |
recency is highly overall correlated with qtd_compras | High correlation |
prod_variety is highly overall correlated with monetary | High correlation |
qtd_returns is highly overall correlated with qtd_compras | High correlation |
monetary is highly skewed (γ1 = 22.58539738) | Skewed |
avg_unit_price is highly skewed (γ1 = 40.02045293) | Skewed |
avg_qtd_items is highly skewed (γ1 = 74.21926571) | Skewed |
qtd_returns is highly skewed (γ1 = 71.05769911) | Skewed |
customer_id has unique values | Unique |
relationship_duration is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
qtd_returns has 4191 (73.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-06-24 11:07:51.237774 |
|---|---|
| Analysis finished | 2023-06-24 11:08:02.793753 |
| Duration | 11.56 seconds |
| Software version | ydata-profiling vv4.2.0 |
| Download configuration | config.json |
customer_id
Real number (ℝ)
| Distinct | 5695 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16600.599 |
| Minimum | 12346 |
|---|---|
| Maximum | 22709 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.0 KiB |
Quantile statistics
| Minimum | 12346 |
|---|---|
| 5-th percentile | 12699.1 |
| Q1 | 14288.5 |
| median | 16227 |
| Q3 | 18210.5 |
| 95-th percentile | 21731.1 |
| Maximum | 22709 |
| Range | 10363 |
| Interquartile range (IQR) | 3922 |
Descriptive statistics
| Standard deviation | 2808.2419 |
|---|---|
| Coefficient of variation (CV) | 0.16916509 |
| Kurtosis | -0.82111592 |
| Mean | 16600.599 |
| Median Absolute Deviation (MAD) | 1963 |
| Skewness | 0.44127055 |
| Sum | 94540411 |
| Variance | 7886222.5 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 12346 | 1 | < 0.1% |
| 17596 | 1 | < 0.1% |
| 17562 | 1 | < 0.1% |
| 17561 | 1 | < 0.1% |
| 17560 | 1 | < 0.1% |
| 17557 | 1 | < 0.1% |
| 17556 | 1 | < 0.1% |
| 17555 | 1 | < 0.1% |
| 17554 | 1 | < 0.1% |
| 17553 | 1 | < 0.1% |
| Other values (5685) | 5685 |
| Value | Count | Frequency (%) |
| 12346 | 1 | |
| 12347 | 1 | |
| 12348 | 1 | |
| 12349 | 1 | |
| 12350 | 1 | |
| 12352 | 1 | |
| 12353 | 1 | |
| 12354 | 1 | |
| 12355 | 1 | |
| 12356 | 1 |
| Value | Count | Frequency (%) |
| 22709 | 1 | |
| 22708 | 1 | |
| 22707 | 1 | |
| 22706 | 1 | |
| 22705 | 1 | |
| 22704 | 1 | |
| 22700 | 1 | |
| 22699 | 1 | |
| 22696 | 1 | |
| 22695 | 1 |
monetary
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 5449 |
|---|---|
| Distinct (%) | 95.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1774.3035 |
| Minimum | 0.42 |
|---|---|
| Maximum | 279138.02 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.0 KiB |
Quantile statistics
| Minimum | 0.42 |
|---|---|
| 5-th percentile | 13.171 |
| Q1 | 236.135 |
| median | 613.2 |
| Q3 | 1570.74 |
| 95-th percentile | 5309.696 |
| Maximum | 279138.02 |
| Range | 279137.6 |
| Interquartile range (IQR) | 1334.605 |
Descriptive statistics
| Standard deviation | 7582.2097 |
|---|---|
| Coefficient of variation (CV) | 4.2733443 |
| Kurtosis | 675.61569 |
| Mean | 1774.3035 |
| Median Absolute Deviation (MAD) | 479.19 |
| Skewness | 22.585397 |
| Sum | 10104658 |
| Variance | 57489903 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7.95 | 9 | 0.2% |
| 1.25 | 8 | 0.1% |
| 2.95 | 8 | 0.1% |
| 4.95 | 8 | 0.1% |
| 3.75 | 7 | 0.1% |
| 1.65 | 7 | 0.1% |
| 12.75 | 7 | 0.1% |
| 7.5 | 6 | 0.1% |
| 5.95 | 6 | 0.1% |
| 4.25 | 6 | 0.1% |
| Other values (5439) | 5623 |
| Value | Count | Frequency (%) |
| 0.42 | 1 | < 0.1% |
| 0.65 | 1 | < 0.1% |
| 0.79 | 1 | < 0.1% |
| 0.84 | 4 | |
| 0.85 | 3 | 0.1% |
| 1.07 | 1 | < 0.1% |
| 1.25 | 8 | |
| 1.44 | 1 | < 0.1% |
| 1.65 | 7 | |
| 1.69 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 279138.02 | 1 | |
| 259657.3 | 1 | |
| 194550.79 | 1 | |
| 140450.72 | 1 | |
| 124564.53 | 1 | |
| 117379.63 | 1 | |
| 91062.38 | 1 | |
| 77183.6 | 1 | |
| 72882.09 | 1 | |
| 66653.56 | 1 |
frequency
Real number (ℝ)
| Distinct | 1226 |
|---|---|
| Distinct (%) | 21.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.54729666 |
| Minimum | 0.0054495913 |
|---|---|
| Maximum | 17 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.0 KiB |
Quantile statistics
| Minimum | 0.0054495913 |
|---|---|
| 5-th percentile | 0.01104363 |
| Q1 | 0.024926433 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 17 |
| Range | 16.99455 |
| Interquartile range (IQR) | 0.97507357 |
Descriptive statistics
| Standard deviation | 0.55025739 |
|---|---|
| Coefficient of variation (CV) | 1.0054097 |
| Kurtosis | 139.13695 |
| Mean | 0.54729666 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.8586449 |
| Sum | 3116.8545 |
| Variance | 0.3027832 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2879 | |
| 2 | 47 | 0.8% |
| 0.0625 | 18 | 0.3% |
| 0.02777777778 | 17 | 0.3% |
| 0.02380952381 | 16 | 0.3% |
| 0.09090909091 | 15 | 0.3% |
| 0.08333333333 | 15 | 0.3% |
| 0.02941176471 | 14 | 0.2% |
| 0.03448275862 | 14 | 0.2% |
| 0.02127659574 | 13 | 0.2% |
| Other values (1216) | 2647 |
| Value | Count | Frequency (%) |
| 0.005449591281 | 1 | < 0.1% |
| 0.005464480874 | 1 | < 0.1% |
| 0.005479452055 | 1 | < 0.1% |
| 0.005494505495 | 1 | < 0.1% |
| 0.005586592179 | 2 | |
| 0.005602240896 | 1 | < 0.1% |
| 0.005617977528 | 2 | |
| 0.00566572238 | 1 | < 0.1% |
| 0.005681818182 | 2 | |
| 0.005698005698 | 3 |
| Value | Count | Frequency (%) |
| 17 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 3 | 5 | 0.1% |
| 2 | 47 | 0.8% |
| 1.142857143 | 1 | < 0.1% |
| 1 | 2879 | |
| 0.75 | 1 | < 0.1% |
| 0.6666666667 | 3 | 0.1% |
| 0.550802139 | 1 | < 0.1% |
| 0.5335120643 | 1 | < 0.1% |
qtd_compras
Real number (ℝ)
| Distinct | 56 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4712906 |
| Minimum | 1 |
|---|---|
| Maximum | 206 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 4 |
| 95-th percentile | 11 |
| Maximum | 206 |
| Range | 205 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 6.8132943 |
|---|---|
| Coefficient of variation (CV) | 1.9627554 |
| Kurtosis | 302.09072 |
| Mean | 3.4712906 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.192783 |
| Sum | 19769 |
| Variance | 46.420979 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2871 | |
| 2 | 825 | 14.5% |
| 3 | 503 | 8.8% |
| 4 | 394 | 6.9% |
| 5 | 237 | 4.2% |
| 6 | 173 | 3.0% |
| 7 | 138 | 2.4% |
| 8 | 98 | 1.7% |
| 9 | 69 | 1.2% |
| 10 | 55 | 1.0% |
| Other values (46) | 332 | 5.8% |
| Value | Count | Frequency (%) |
| 1 | 2871 | |
| 2 | 825 | 14.5% |
| 3 | 503 | 8.8% |
| 4 | 394 | 6.9% |
| 5 | 237 | 4.2% |
| 6 | 173 | 3.0% |
| 7 | 138 | 2.4% |
| 8 | 98 | 1.7% |
| 9 | 69 | 1.2% |
| 10 | 55 | 1.0% |
| Value | Count | Frequency (%) |
| 206 | 1 | |
| 199 | 1 | |
| 124 | 1 | |
| 97 | 1 | |
| 91 | 2 | |
| 86 | 1 | |
| 72 | 1 | |
| 62 | 2 | |
| 60 | 1 | |
| 57 | 1 |
recency
Real number (ℝ)
| Distinct | 304 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 116.92766 |
| Minimum | 0 |
|---|---|
| Maximum | 373 |
| Zeros | 37 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 23 |
| median | 71 |
| Q3 | 200 |
| 95-th percentile | 338 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 177 |
Descriptive statistics
| Standard deviation | 111.64636 |
|---|---|
| Coefficient of variation (CV) | 0.95483282 |
| Kurtosis | -0.64262595 |
| Mean | 116.92766 |
| Median Absolute Deviation (MAD) | 61 |
| Skewness | 0.81431448 |
| Sum | 665903 |
| Variance | 12464.91 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 110 | 1.9% |
| 4 | 105 | 1.8% |
| 3 | 98 | 1.7% |
| 2 | 92 | 1.6% |
| 10 | 86 | 1.5% |
| 8 | 82 | 1.4% |
| 17 | 79 | 1.4% |
| 9 | 79 | 1.4% |
| 7 | 78 | 1.4% |
| 15 | 66 | 1.2% |
| Other values (294) | 4820 |
| Value | Count | Frequency (%) |
| 0 | 37 | 0.6% |
| 1 | 110 | |
| 2 | 92 | |
| 3 | 98 | |
| 4 | 105 | |
| 5 | 52 | |
| 7 | 78 | |
| 8 | 82 | |
| 9 | 79 | |
| 10 | 86 |
| Value | Count | Frequency (%) |
| 373 | 23 | |
| 372 | 23 | |
| 371 | 17 | |
| 369 | 4 | 0.1% |
| 368 | 13 | |
| 367 | 16 | |
| 366 | 15 | |
| 365 | 19 | |
| 364 | 11 | |
| 362 | 7 | 0.1% |
avg_unit_price
Real number (ℝ)
| Distinct | 5266 |
|---|---|
| Distinct (%) | 92.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7157081 |
| Minimum | 0.06 |
|---|---|
| Maximum | 434.65 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.0 KiB |
Quantile statistics
| Minimum | 0.06 |
|---|---|
| 5-th percentile | 1.2510829 |
| Q1 | 2.2175 |
| median | 3.0477976 |
| Q3 | 4.25 |
| 95-th percentile | 6.6995626 |
| Maximum | 434.65 |
| Range | 434.59 |
| Interquartile range (IQR) | 2.0325 |
Descriptive statistics
| Standard deviation | 7.8490615 |
|---|---|
| Coefficient of variation (CV) | 2.1123999 |
| Kurtosis | 1952.83 |
| Mean | 3.7157081 |
| Median Absolute Deviation (MAD) | 0.95835623 |
| Skewness | 40.020453 |
| Sum | 21160.958 |
| Variance | 61.607767 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.25 | 26 | 0.5% |
| 4.95 | 20 | 0.4% |
| 0.85 | 18 | 0.3% |
| 3.75 | 16 | 0.3% |
| 2.95 | 15 | 0.3% |
| 1.65 | 14 | 0.2% |
| 2.08 | 13 | 0.2% |
| 0.42 | 13 | 0.2% |
| 12.75 | 12 | 0.2% |
| 7.95 | 12 | 0.2% |
| Other values (5256) | 5536 |
| Value | Count | Frequency (%) |
| 0.06 | 1 | |
| 0.1225 | 1 | |
| 0.17 | 2 | |
| 0.2327777778 | 1 | |
| 0.29 | 2 | |
| 0.32 | 1 | |
| 0.33 | 1 | |
| 0.355 | 2 | |
| 0.358 | 1 | |
| 0.3666666667 | 1 |
| Value | Count | Frequency (%) |
| 434.65 | 1 | |
| 295 | 1 | |
| 125 | 1 | |
| 110 | 2 | |
| 74.975 | 1 | |
| 66.475 | 1 | |
| 59.73333333 | 1 | |
| 54.3 | 1 | |
| 51.71 | 1 | |
| 39.95 | 1 |
avg_qtd_items
Real number (ℝ)
| Distinct | 4270 |
|---|---|
| Distinct (%) | 75.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.910403 |
| Minimum | 1 |
|---|---|
| Maximum | 74215 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1.2301099 |
| Q1 | 2.9541958 |
| median | 8.1594533 |
| Q3 | 12.903191 |
| 95-th percentile | 39.548387 |
| Maximum | 74215 |
| Range | 74214 |
| Interquartile range (IQR) | 9.9489957 |
Descriptive statistics
| Standard deviation | 988.80893 |
|---|---|
| Coefficient of variation (CV) | 31.989519 |
| Kurtosis | 5566.838 |
| Mean | 30.910403 |
| Median Absolute Deviation (MAD) | 5.0772615 |
| Skewness | 74.219266 |
| Sum | 176034.74 |
| Variance | 977743.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 237 | 4.2% |
| 2 | 51 | 0.9% |
| 4 | 33 | 0.6% |
| 10 | 31 | 0.5% |
| 1.5 | 29 | 0.5% |
| 12 | 27 | 0.5% |
| 3 | 25 | 0.4% |
| 6 | 23 | 0.4% |
| 1.333333333 | 20 | 0.4% |
| 5 | 19 | 0.3% |
| Other values (4260) | 5200 |
| Value | Count | Frequency (%) |
| 1 | 237 | |
| 1.052631579 | 1 | < 0.1% |
| 1.055555556 | 1 | < 0.1% |
| 1.057142857 | 1 | < 0.1% |
| 1.0625 | 2 | < 0.1% |
| 1.066666667 | 1 | < 0.1% |
| 1.071428571 | 1 | < 0.1% |
| 1.08 | 1 | < 0.1% |
| 1.094339623 | 1 | < 0.1% |
| 1.1 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 74215 | 1 | |
| 4300 | 1 | |
| 3906 | 1 | |
| 2140 | 1 | |
| 2000 | 1 | |
| 1802.8 | 1 | |
| 1756.5 | 1 | |
| 1440 | 1 | |
| 1404 | 1 | |
| 1350 | 1 |
prod_variety
Real number (ℝ)
| Distinct | 439 |
|---|---|
| Distinct (%) | 7.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 69.669535 |
| Minimum | 1 |
|---|---|
| Maximum | 1786 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 13 |
| median | 36 |
| Q3 | 84.5 |
| 95-th percentile | 241.3 |
| Maximum | 1786 |
| Range | 1785 |
| Interquartile range (IQR) | 71.5 |
Descriptive statistics
| Standard deviation | 101.73049 |
|---|---|
| Coefficient of variation (CV) | 1.4601861 |
| Kurtosis | 43.880529 |
| Mean | 69.669535 |
| Median Absolute Deviation (MAD) | 28 |
| Skewness | 4.7034268 |
| Sum | 396768 |
| Variance | 10349.092 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 279 | 4.9% |
| 2 | 149 | 2.6% |
| 3 | 112 | 2.0% |
| 10 | 101 | 1.8% |
| 5 | 98 | 1.7% |
| 9 | 96 | 1.7% |
| 6 | 93 | 1.6% |
| 8 | 93 | 1.6% |
| 11 | 92 | 1.6% |
| 4 | 90 | 1.6% |
| Other values (429) | 4492 |
| Value | Count | Frequency (%) |
| 1 | 279 | |
| 2 | 149 | |
| 3 | 112 | |
| 4 | 90 | 1.6% |
| 5 | 98 | 1.7% |
| 6 | 93 | 1.6% |
| 7 | 90 | 1.6% |
| 8 | 93 | 1.6% |
| 9 | 96 | 1.7% |
| 10 | 101 | 1.8% |
| Value | Count | Frequency (%) |
| 1786 | 1 | |
| 1766 | 1 | |
| 1322 | 1 | |
| 1118 | 1 | |
| 1109 | 1 | |
| 884 | 1 | |
| 817 | 1 | |
| 748 | 1 | |
| 730 | 1 | |
| 720 | 1 |
relationship_duration
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 89.0 KiB |
qtd_returns
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 214 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.268306 |
| Minimum | 0 |
|---|---|
| Maximum | 74215 |
| Zeros | 4191 |
| Zeros (%) | 73.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 89.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 38.3 |
| Maximum | 74215 |
| Range | 74215 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1004.3217 |
|---|---|
| Coefficient of variation (CV) | 32.11948 |
| Kurtosis | 5232.3595 |
| Mean | 31.268306 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 71.057699 |
| Sum | 178073 |
| Variance | 1008662.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4191 | |
| 1 | 169 | 3.0% |
| 2 | 150 | 2.6% |
| 3 | 105 | 1.8% |
| 4 | 89 | 1.6% |
| 6 | 78 | 1.4% |
| 5 | 61 | 1.1% |
| 12 | 52 | 0.9% |
| 7 | 44 | 0.8% |
| 8 | 43 | 0.8% |
| Other values (204) | 713 | 12.5% |
| Value | Count | Frequency (%) |
| 0 | 4191 | |
| 1 | 169 | 3.0% |
| 2 | 150 | 2.6% |
| 3 | 105 | 1.8% |
| 4 | 89 | 1.6% |
| 5 | 61 | 1.1% |
| 6 | 78 | 1.4% |
| 7 | 44 | 0.8% |
| 8 | 43 | 0.8% |
| 9 | 41 | 0.7% |
| Value | Count | Frequency (%) |
| 74215 | 1 | |
| 9014 | 1 | |
| 8004 | 1 | |
| 4427 | 1 | |
| 3768 | 1 | |
| 3332 | 1 | |
| 2878 | 1 | |
| 2022 | 1 | |
| 2012 | 1 | |
| 1776 | 1 |
| customer_id | monetary | frequency | qtd_compras | recency | avg_unit_price | avg_qtd_items | prod_variety | qtd_returns | |
|---|---|---|---|---|---|---|---|---|---|
| customer_id | 1.000 | -0.181 | 0.380 | -0.383 | 0.245 | 0.217 | -0.493 | -0.017 | -0.277 |
| monetary | -0.181 | 1.000 | -0.453 | 0.644 | -0.426 | 0.078 | 0.322 | 0.795 | 0.433 |
| frequency | 0.380 | -0.453 | 1.000 | -0.799 | 0.486 | 0.153 | -0.321 | -0.312 | -0.366 |
| qtd_compras | -0.383 | 0.644 | -0.799 | 1.000 | -0.597 | -0.166 | 0.361 | 0.450 | 0.538 |
| recency | 0.245 | -0.426 | 0.486 | -0.597 | 1.000 | 0.203 | -0.272 | -0.327 | -0.320 |
| avg_unit_price | 0.217 | 0.078 | 0.153 | -0.166 | 0.203 | 1.000 | -0.367 | 0.064 | -0.062 |
| avg_qtd_items | -0.493 | 0.322 | -0.321 | 0.361 | -0.272 | -0.367 | 1.000 | -0.124 | 0.297 |
| prod_variety | -0.017 | 0.795 | -0.312 | 0.450 | -0.327 | 0.064 | -0.124 | 1.000 | 0.270 |
| qtd_returns | -0.277 | 0.433 | -0.366 | 0.538 | -0.320 | -0.062 | 0.297 | 0.270 | 1.000 |
| customer_id | monetary | frequency | qtd_compras | recency | avg_unit_price | avg_qtd_items | prod_variety | relationship_duration | qtd_returns | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 12346.0 | 77183.60 | 1.000000 | 1 | 325 | 1.040000 | 74215.000000 | 1 | 0 days | 74215.0 |
| 1 | 12347.0 | 4310.00 | 0.019126 | 7 | 2 | 2.644011 | 13.505495 | 103 | 365 days | 0.0 |
| 2 | 12348.0 | 1437.24 | 0.014085 | 4 | 75 | 0.692963 | 86.370370 | 21 | 283 days | 0.0 |
| 3 | 12349.0 | 1457.55 | 1.000000 | 1 | 18 | 4.237500 | 8.750000 | 72 | 0 days | 0.0 |
| 4 | 12350.0 | 294.40 | 1.000000 | 1 | 310 | 1.581250 | 12.250000 | 16 | 0 days | 0.0 |
| 5 | 12352.0 | 1385.74 | 0.026820 | 7 | 36 | 4.075455 | 6.831169 | 57 | 260 days | 63.0 |
| 6 | 12353.0 | 89.00 | 1.000000 | 1 | 204 | 6.075000 | 5.000000 | 4 | 0 days | 0.0 |
| 7 | 12354.0 | 1079.40 | 1.000000 | 1 | 232 | 4.503793 | 9.137931 | 58 | 0 days | 0.0 |
| 8 | 12355.0 | 459.40 | 1.000000 | 1 | 214 | 4.203846 | 18.461538 | 13 | 0 days | 0.0 |
| 9 | 12356.0 | 2487.43 | 0.009868 | 3 | 22 | 2.946034 | 27.120690 | 52 | 303 days | 0.0 |
| customer_id | monetary | frequency | qtd_compras | recency | avg_unit_price | avg_qtd_items | prod_variety | relationship_duration | qtd_returns | |
|---|---|---|---|---|---|---|---|---|---|---|
| 5685 | 22695.0 | 6083.95 | 1.0 | 1 | 1 | 4.256074 | 2.743704 | 675 | 0 days | 0.0 |
| 5686 | 22696.0 | 7150.07 | 1.0 | 1 | 1 | 4.292594 | 2.874332 | 748 | 0 days | 0.0 |
| 5687 | 22699.0 | 3686.80 | 1.0 | 1 | 1 | 5.772315 | 3.403941 | 203 | 0 days | 0.0 |
| 5688 | 22700.0 | 4839.42 | 1.0 | 1 | 1 | 7.254516 | 17.322581 | 55 | 0 days | 0.0 |
| 5689 | 22704.0 | 17.90 | 1.0 | 1 | 1 | 1.278571 | 2.000000 | 7 | 0 days | 0.0 |
| 5690 | 22705.0 | 3.35 | 1.0 | 1 | 1 | 1.675000 | 1.000000 | 2 | 0 days | 0.0 |
| 5691 | 22706.0 | 5699.00 | 1.0 | 1 | 1 | 4.320946 | 2.755521 | 634 | 0 days | 0.0 |
| 5692 | 22707.0 | 6756.06 | 1.0 | 1 | 0 | 4.175904 | 2.753425 | 730 | 0 days | 0.0 |
| 5693 | 22708.0 | 3217.20 | 1.0 | 1 | 0 | 6.269661 | 11.084746 | 56 | 0 days | 0.0 |
| 5694 | 22709.0 | 3950.72 | 1.0 | 1 | 0 | 6.364378 | 3.368664 | 217 | 0 days | 0.0 |